🕷️️ Job Radar • SCRAPING

freelancer.com 🟢 2026-05-13

🔹 Web-based Google Ads CSV Generator or Direct API Tool
👤 Client: 🇬🇧 Stafford, United Kingdom Member since 2019-03-21
💰 Price: $196 Average bid
🚩 Problem: Ensure accurate and efficient keyword matching for thousands of ads to avoid traffic misdirection.
📦 Existing: Not specified

Specifications:

[Target] Match product part numbers, keywords, and URLs accurately for Google Ads campaigns.
[Method] Implement a web-based tool with direct Google Ads API integration.
[UI/UX] Provide an intuitive interface for uploading input data (CSV, Excel, Google Sheets), reviewing matches, and exporting results.
[Stack] Use React for UI, Node.js for backend, PostgreSQL for database, and Google Ads API for integration.
[Security] Ensure secure user authentication and data handling with OAuth 2.0 and HTTPS.
[Format] Output CSV files compatible with Google Ads Editor or bulk upload templates.

Workflow:

1. Upload input data (CSV, Excel, Google Sheets) containing columns like part_number, keyword, campaign, ad_group, match_type.
2. Crawl/sync new website product URLs and store them in a database with associated part numbers, titles, categories, manufacturers/brands, alternative part numbers, and page status.
3. Implement matching engine: exact part-number match first, normalized match second (remove spaces, dashes, slashes, case differences), fuzzy/keyword match third, AI-assisted fallback for weak cases, and human review screen with confidence scores.
4. Provide a human review screen showing input part number/keyword, matched URL, confidence score, reason for match, warnings, and allow manual override before export.
5. Generate Google Ads-ready CSV with columns: Campaign, Ad group, Keyword, Match type, Final URL, Status.
6. Ensure Google Ads Editor identifies keyword rows using campaign, ad group, keyword text, and match type.
7. Allow setting final URLs at the keyword level to override ad-level URLs.